Trigger Name
Set the trigger name.
Compound
Check to set the trigger as a compound trigger.
For each
Set the trigger as a row trigger or statement trigger.
Fires
Specify the trigger timing whether the trigger action is to be run before or after the triggering statement.
DELETE - fires the trigger whenever a DELETE statement removes a row from the table or removes an element from a nested table. INSERT - fires the trigger whenever an INSERT statement adds a row to a table or adds an element to a nested table. UPDATE - fires the trigger whenever an UPDATE statement changes a value in one of the columns specified in Update Of. If no Update Of are present, the trigger will be fired whenever an UPDATE statement changes a value in any column of the table or nested table.
Update Of
Specify the fields for UPDATE statement trigger upon necessary. Click to select field(s).
Enable
You can choose whether to enable / disable the trigger constraint by checking / unchecking the box.
Body
Type in the definition for the trigger.
Example:BEGIN add_job_history(:old.employee_id, :old.hire_date, sysdate, :old.job_id, :old.department_id); END;
Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.
Advanced
Referencing
Specify correlation names. The default correlation names are OLD and NEW.When
Specify the trigger condition, which is a SQL condition that must be satisfied for the database to fire the trigger. This condition must contain correlation names and cannot contain a query.Schema
Define the trigger on the current schema.Follows
Specify the relative firing order of triggers of the same type.